Hệ thống quản lý trường học bằng PHP / MySQLi
1
2 <?php
3 SESSION_START();
4 ?>
5 <?php
6 error_reporting(0);
7 include("connect.php");
8 ?>
9 <!DOCTYPE html>
10 <html>
11
12 <head>
13 <meta charset="utf-8">
14 <meta name="viewport" content="width=device-width, initial-scale=1.0">
15 <title>school management system</title>
16 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
17 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
18 <link href="assets/css/loader.css" rel="stylesheet" />
19 <script src="assets/js/canvasjs.min.js"></script>
20 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
21 <script src="assets/js/jquery-3.2.1.js"></script>
22 <!--this two links are for styling up the table populated with data-->
23 <link rel="stylesheet" type="text/css" href="styles.css" />
24 <script language="javascript" src="users.js" type="text/javascript"></script>
25 </head>
26
27 <body >
28 <!--end of heading section-->
29 <ul class="nav navbar-right top-nav">
30 <div class="dropdown">
31 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
32 <?php
33 //Check to see if the user is logged in.if not redirect user to the loging page.
34
35 if(isset($_SESSION['fname']))
36 {
37 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
38 }else{
39 echo "<script type='text/javascript'>
40 alert( 'You must Log in to use the system');
41 </script>";
42 echo "<script>
43 window.location = 'index.php'
44 </script>";
45 }
46 ?>
47 <span class="caret"></span></button>
48 <ul class="dropdown-menu">
49 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
50 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
51 <li class="divider"></li>
52 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
53 </ul>
54 </div>
55 </ul>
56 <!--************************************************-->
57 <div style="
58 font-family:Nyala, Arial;
59 text-align: left;
60 background-color: #526F35;
61 padding: 20px;
62 color:white;
63 width: 100%;
64 height: 150px;">
65 <!--This codes to load the image loader-->
66 <div id="loading">
67 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
68 </div>
69 <!--this is the heading section-->
70 <h2>
71 <?php
72 $sql="SELECT * FROM companyinfo";
73 $result=mysqli_query($db,$sql) or die("error getting data");
74 $num_rows=mysqli_num_rows($result);
75 while($row=mysqli_fetch_array($result))
76 {
77 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
78 $cname = $row['cname'];
79 $cemail = $row['cemail'];
80 $ccontact = $row['ccontact'];
81 $clocation = $row['clocation'];
82 }?>
83 <?php
84 echo $cname;
85 ?>
86
87 <div style="float:right; font-size:20px;text-align:right;">
88
89 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
90 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
91 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
92
93 </div>
94 </h2>
95 </div>
96 <!--end of heading section-->
97 <div>
98 <ul class="nav nav-tabs">
99 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
100 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
101 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
102 <li><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
103 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
104 <li><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
105 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
106 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
107 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
108 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
109
110 </ul>
111 <div class="tab-content">
112 <div class="tab-pane active" role="tabpanel" id="tab-1">
113
114 <p>
115 <div class="table-responsive" >
116 <!--****************************************************************************-->
117 <div class="container" style="width:100%">
118
119 <ul class="nav nav-tabs">
120 <li ><a href="pro1.php">Choose Class <img src="assets/img/new.png"> </a></li>
121 <li class="active"><a href="pro2.php">Check List<img src="assets/img/view2.png"></a></li>
122 <li><a href="pro3.php">Edit Student<img src="assets/img/view2.png"></a></li>
123 <li ><a href="#"><font color="red"><i>You are about to promote students in D [<?php echo $_GET['id'] ; ?>] </i></font><img src="assets/img/promote.png"></a></li>
124 </ul>
125 <br>
126
127 </div>
128
129 <!--*************************************************************************************************************************-->
130
131 <div id="page-wrapper">
132 <div class="container-fluid">
133
134
135 <!-- Page Heading -->
136 <nav>
137
138 <!--*************this is javascript codes to check all. it works in chrome and IE9 -->
139 <form name="frmUser" method="post" action="">
140 <div style="width:100%;">
141
142
143 <script language="JavaScript">
144 function toggle(source) {
145 var checkboxes = document.querySelectorAll('input[type="checkbox"]');
146 for (var i = 0; i < checkboxes.length; i++) {
147 if (checkboxes[i] != source)
148 checkboxes[i].checked = source.checked;
149 }
150 }
151 </script>
152
153 <!--*************this is the end of javascript codes to check all-->
154
155 <?php
156 error_reporting(0);
157 $id=$_GET['id'];
158 $conn = mysqli_connect("localhost","root","");
159 mysqli_select_db("sms2",$conn);
160 $result = mysqli_query("SELECT * FROM studentstable WHERE course_id='$id'");
161 ?>
162
163 <div class="table-responsive">
164 <table cellpadding="0" cellspacing="0" border="0" class="table" id="myTable">
165
166 <tr class="listheader">
167 <td>Check all<br><input type="checkbox" onClick="toggle(this)" ><br/></td>
168 <td>Student ID</td>
169 <td>Sir Name</td>
170 <td>First Name</td>
171 <td>Last Name</td>
172 <td>Date of Birth</td>
173 <td>Gender</td>
174 <td>Course ID</td>
175 <td>Intake ID</td>
176 <td>Reg Date</td>
177 <td>Fee Payable</td>
178 <td>County ID</td>
179 <td>Constituency ID</td>
180 <td>Mobile</td>
181 <td>Address</td>
182 <td>Zip Code</td>
183 <td>Email</td>
184 </tr>
185 <?php
186 $i=0;
187 while($row = mysqli_fetch_array($result)) {
188 if($i%2==0)
189 $classname="evenRow";
190 else
191 $classname="oddRow";
192 ?>
193 <tr class="<?php if(isset($classname)) echo $classname;?>">
194 <td><input type="checkbox" name="users[]" value="<?php echo $row["student_id"]; ?>" ></td>
195 <td><?php echo $row["student_id"]; ?></td>
196 <td><?php echo $row["sirname"]; ?></td>
197 <td><?php echo $row["firstname"]; ?></td>
198 <td><?php echo $row["lastname"]; ?></td>
199 <td><?php echo $row["dateofbirth"]; ?></td>
200 <td><?php echo $row["gender"]; ?></td>
201 <td><?php echo $row["course_id"]; ?></td>
202 <td><?php echo $row["intake_id"]; ?></td>
203 <td><?php echo $row["reg_date"]; ?></td>
204 <td><?php echo $row["feepayable"]; ?></td>
205 <td><?php echo $row["county_id"]; ?></td>
206 <td><?php echo $row["constituency_id"]; ?></td>
207 <td><?php echo $row["mobile"]; ?></td>
208 <td><?php echo $row["address"]; ?></td>
209 <td><?php echo $row["zipcode"]; ?></td>
210 <td><?php echo $row["email"]; ?></td>
211 </tr>
212 <?php
213 $i++;
214 }
215 ?>
216 <tr class="listheader">
217 <td colspan="4"><input type="button" name="update" value="Promote" onClick="setUpdateAction();" />
218 <!--<input type="button" name="delete" value="Delete" onClick="setDeleteAction();" /></td>-->
219 </tr>
220 </table>
221 </form>
222 </div>
223 </div>
224 </div>
225 </div>
226
227 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
228 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
229 </div>
230 <script src="assets/js/jquery.min.js"></script>
231 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
232 <script src="assets/js/affix.js"></script>
233 <script src="assets/js/alert.js"></script>
234 <script src="assets/js/alert1.js"></script>
235 <script src="assets/js/bootstrap.js"></script>
236 <script src="assets/js/bootstrap.min.js"></script>
237 <script src="assets/js/bootstrap-datepicker.js"></script>
238 <script src="assets/js/bootstrap-wysihtml5.js"></script>
239 <script src="assets/js/button.js"></script>
240 <script src="assets/js/carousel.js"></script>
241 <script src="assets/js/chosen.jquery.min.js"></script>
242 <script src="assets/js/ckeditor.js"></script>
243 <script src="assets/js/collapse.js"></script>
244 <script src="assets/js/color.js"></script>
245 <script src="assets/js/dropdown.js"></script>
246 <script src="assets/js/DT_bootstrap.js"></script>
247 <script src="assets/js/dynamic.js"></script>
248 <script src="assets/js/ie-emulation-modes-warning.js"></script>
249 <script src="assets/js/jquery.dataTables.js"></script>
250 <script src="assets/js/jquery.dataTables.min.js"></script>
251 <script src="assets/js/jquery.dialog.js"></script>
252 <script src="assets/js/jquery.hoverdir.js"></script>
253 <script src="assets/js/jquery.jgrowl.js"></script>
254 <script src="assets/js/jquery.knob.js"></script>
255 <script src="assets/js/jquery.uniform.min.js"></script>
256 <script src="assets/js/jquery-1.8.3.min.js"></script>
257 <script src="assets/js/jquery-1.9.1.js"></script>
258 <script src="assets/js/jquery-1.9.1.min.js"></script>
259 <script src="assets/js/jquery-1.10.2.js"></script>
260 <script src="assets/js/jquery-1.11.0.js"></script>
261 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
262 <script src="assets/js/jquery-ui-1.10.3.js"></script>
263 <script src="assets/js/modal.js"></script>
264 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
265 <script src="assets/js/myjquery.js"></script>
266 <script src="assets/js/myjquery1.js"></script>
267 <script src="assets/js/npm.js"></script>
268 <script src="assets/js/popover.js"></script>
269 <script src="assets/js/profile.js"></script>
270 <script src="assets/js/raphael-min.js"></script>
271 <script src="assets/js/sb-admin-2.js"></script>
272 <script src="assets/js/scripts.js"></script>
273 <script src="assets/js/scrollspy.js"></script>
274 <script src="assets/js/tab.js"></script>
275 <script src="assets/js/tooltip.js"></script>
276 <script src="assets/js/transition.js"></script>
277 <script src="assets/js/wysihtml5-0.3.0.js"></script>
278 <script language="javascript" type="text/javascript">
279 $(window).load(function()
280 {
281 $('#loading').hide();
282 });
283 </script>
284 </body>
285
286 </html>
